package metrics_sql

const (
	K8sPodContainer = `
agent = "prometheus-%v-0"
app = "%v"
container = "%v"

from(bucket: "data")
  |> range(start: %v, stop: %v)
  |> filter(fn: (r) => r["_measurement"] == "prometheus_remote_write")
  |> filter(fn: (r) => r["_field"] == "kube_pod_container_info")
  |> filter(fn: (r) => r["prometheus_replica"] == agent)
  |> filter(fn: (r) => r["namespace"] == app)
  |> filter(fn: (r) => r["container"] == container)
  |> last()
  |> drop(columns: ["prometheus_replica","prometheus","job","instance","host","_measurement","_value","_start","_stop","_time","_field"])
`
)
